create database - Docs search results , p.2

CREATE TABLESPACE

CREATE DATABASE , CREATE TABLE , CREATE INDEX or ADD CONSTRAINT to have the data files for these

23.1. Locale Support

database cluster is created using initdb . initdb will initialize the database cluster with the locale

createuser

create databases. -D --no-createdb The new user will not be allowed to create databases

25.3. Continuous Archiving and Point-in-Time Recovery (PITR)

database that the CREATE DATABASE copied is modified while the base backup is still in progress

21.2. Role Attributes

database user ” . To create a role with login privilege, use either: CREATE ROLE name LOGIN

pg_dumpall

database creation will fail for databases in non-default locations. Examples To dump all databases

SHOW

database creation time. LC_COLLATE Shows the database's locale setting for collation (text ordering

F.35. sepgsql

Creating a new database object requires create permission. SELinux will grant or deny this permission

CREATE COLLATION

database encoding. (See CREATE DATABASE for the precise rules.) lc_ctype Use the specified operating

CREATE LANGUAGE

created by database owners ( tmpldbacreate is true). The default is that trusted languages can be created

40.1. Installing Procedural Languages

database template1 are automatically available in all subsequently created databases, since their entries in template1

GRANT

CREATE | CONNECT | TEMPORARY | TEMP } [, ...] | ALL [ PRIVILEGES ] } ON DATABASE database_name [, ...] TO role_specification [, ...] [ WITH GRANT

13.5. Caveats

created database objects such as tables are visible to concurrent Repeatable Read and Serializable transactions

22.1. Overview

Databases are created with the CREATE DATABASE command (see Section 22.2 ) and destroyed with the DROP

50.15. pg_database

Databases are created with the CREATE DATABASE command. Consult Chapter 22 for details about the meaning